Use the Name edit box to enter a name for the new key and then select a table field to include in the key from the Field(s) Name group.
Use the Reference Database and Reference Table dropdown lists to select a foreign database and table respectively.
To include field(s) to the key, just simply click the Field(s) Name/Foreign
Field(s) Name to open the
editor(s) for editing.
The On Delete and On Update dropdown list define the type of the actions to be taken.
CASCADE
Delete the corresponding foreign key, or update the corresponding foreign key to the new value of the primary key.SET NULL
Set all the columns of the corresponding foreign key to NULL.NO ACTION
Does not change the foreign key.RESTRICT
Produce an error indicating that the deletion or update would create a foreign key constraint violation.